"""
Case Type   : 资源池化故障模式库
Case Name   : stat文件丢失-删除stat文件
Create At   : 2025/04
Owner       : haomeng
Description :
    1、查看集群状态
    2、运行tpcc业务
    3、删除主节点stat文件
    4、查看业务运行情况
    5、重启集群
    6、查看集群状态
Expect      :
    1、集群状态正常
    2、运行业务成功
    3、删除主节点stat文件成功
    4、业务运行正常无影响
    5、重启集群成功
    6、集群状态正常
History     :
"""

import os
import time
import unittest

from testcase.utils.Common import Common
from testcase.utils.CommonSH import CommonSH
from testcase.utils.ComThread import ComThread
from testcase.utils.Constant import Constant
from testcase.utils.Logger import Logger
from yat.test import Node
from yat.test import macro

class SSFauleMode(unittest.TestCase):

    def setUp(self):
        self.log = Logger()
        self.log.info(f'----{os.path.basename(__file__)} start----')
        self.user_node = [Node(node='PrimaryRoot'), Node(node='PrimaryDbUser')]
        self.pri_sh = CommonSH('PrimaryDbUser')
        self.com = Common()
        self.constant = Constant()
        self.state_file = os.path.join(macro.DB_INSTANCE_PATH, macro.STATE_FILE_NAME)

    def test_ss_faule(self):
        text = '-----step1:查看集群状态;  expect:集群状态正常-----'
        self.log.info(text)

        status = self.pri_sh.exec_cm_ctl('query', '-Cv')
        self.log.info(status)
        self.assertIn('Normal', status, '集群状态异常')

        text = '-----step2:执行tpcc读写业务  expect:业务执行成功-----'
        self.log.info(text)

        tpcc_cmd = f'./runBenchmark.sh {macro.PROPS_FILENAME}'
        self.log.info(tpcc_cmd)

        tpcc_execute = ComThread(self.com.start_tpcc, args=(self.user_node[0],
                                                               f'{macro.TPCC_PATH}',
                                                               tpcc_cmd))
        tpcc_execute.setDaemon(True)
        tpcc_execute.start()

        text = '-----step3:删除主节点state文件  expect:删除成功-----'
        self.log.info(text)

        delete = f'rm -rf {self.state_file};' \
                 f'ls {self.state_file};'
        self.log.info(delete)

        delete_execute = ComThread(self.com.get_sh_result, args=(self.user_node[1], delete))
        delete_execute.setDaemon(True)
        delete_execute.start()

        text = '-----step4:查看业务运行情况  expect:业务运行正常无影响-----'
        self.log.info(text)

        tpcc_execute.join()
        ret1 = tpcc_execute.get_result()
        self.log.info(ret1)
        self.assertIn('Session End', ret1, 'tpcc执行失败')

        delete_execute.join()
        ret2 = delete_execute.get_result()
        self.log.info(ret2)
        self.assertIn('No such file or directory', ret2, '删除postgresql.conf文件失败')

        text = '-----step5:重启集群  expect:重启成功-----'
        self.log.info(text)

        restart = self.pri_sh.exec_cm_ctl('stop;', 'cm_ctl start')
        self.log.info(restart)
        self.assertIn(self.constant.cm_stop_success_msg, restart, '重启集群失败')

        text = '-----step6:查看集群状态  expect:集群状态正常-----'
        self.log.info(text)

        status = self.pri_sh.exec_cm_ctl('query', '-Cv')
        self.log.info(status)
        self.assertIn('cluster_state   : Normal', status, '集群状态正常')
        self.assertIn('P Primary', status, '集群状态异常')

    def tearDown(self):
        self.log.info('-----No need to clean-----')
        self.log.info(f'----{os.path.basename(__file__)} end----')
